/*
 Navicat Premium Dump SQL

 Source Server         : M_root@localhost
 Source Server Type    : MySQL
 Source Server Version : 90200 (9.2.0)
 Source Host           : localhost:3306
 Source Schema         : kafkatool

 Target Server Type    : MySQL
 Target Server Version : 90200 (9.2.0)
 File Encoding         : 65001

 Date: 26/07/2025 23:53:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(80) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (20, 'Can view content type', 5, 'view_contenttype');
COMMIT;

-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `password` varchar(128) COLLATE utf8mb4_general_ci NOT NULL,
  `last_login` datetime(6) NOT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `first_name` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `last_name` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(75) COLLATE utf8mb4_general_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext COLLATE utf8mb4_general_ci,
  `object_repr` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `app_label` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `model` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (1, '', 'admin', 'logentry');
INSERT INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (2, '', 'auth', 'permission');
INSERT INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (3, '', 'auth', 'group');
INSERT INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (4, '', 'auth', 'user');
INSERT INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (5, '', 'contenttypes', 'contenttype');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (1, 'contenttypes', '0001_initial', '2025-07-25 13:35:50.244568');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (2, 'auth', '0001_initial', '2025-07-25 13:35:50.446220');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (3, 'admin', '0001_initial', '2025-07-25 13:35:50.486594');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2025-07-25 13:35:50.489568');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2025-07-25 13:35:50.492098');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (6, 'api', '0001_initial', '2025-07-25 13:36:10.725807');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (7, 'contenttypes', '0002_remove_content_type_name', '2025-07-25 13:36:10.730969');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (8, 'auth', '0002_alter_permission_name_max_length', '2025-07-25 13:36:10.733338');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (9, 'auth', '0003_alter_user_email_max_length', '2025-07-25 13:36:10.735569');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (10, 'auth', '0004_alter_user_username_opts', '2025-07-25 13:36:10.737063');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (11, 'auth', '0005_alter_user_last_login_null', '2025-07-25 13:36:10.738179');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (12, 'auth', '0006_require_contenttypes_0002', '2025-07-25 13:36:10.739343');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (13, 'auth', '0007_alter_validators_add_error_messages', '2025-07-25 13:36:10.740332');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (14, 'auth', '0008_alter_user_username_max_length', '2025-07-25 13:36:10.741293');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (15, 'auth', '0009_alter_user_last_name_max_length', '2025-07-25 13:36:10.742305');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (16, 'auth', '0010_alter_group_name_max_length', '2025-07-25 13:36:10.743883');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (17, 'auth', '0011_update_proxy_permissions', '2025-07-25 13:36:10.745062');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (18, 'auth', '0012_alter_user_first_name_max_length', '2025-07-25 13:36:10.745911');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (19, 'sessions', '0001_initial', '2025-07-25 13:36:10.746718');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (20, 'api', '0002_kafkaconfig_remove_jsondata_created_at_and_more', '2025-07-26 06:03:01.402368');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (21, 'api', '0003_kafkaconfig_json', '2025-07-26 06:03:01.414340');
COMMIT;

-- ----------------------------
-- Table structure for k_config
-- ----------------------------
DROP TABLE IF EXISTS `k_config`;
CREATE TABLE `k_config` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置名称',
  `url` varchar(256) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'kafka服务器url',
  `topic` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '主题名称',
  `json` varchar(4000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'json数据',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='kafka配置';

-- ----------------------------
-- Records of k_config
-- ----------------------------
BEGIN;
INSERT INTO `k_config` (`id`, `name`, `url`, `topic`, `json`) VALUES (3, '配置1', 'localhost:9092', 'test', NULL);
COMMIT;

-- ----------------------------
-- Table structure for k_key_map
-- ----------------------------
DROP TABLE IF EXISTS `k_key_map`;
CREATE TABLE `k_key_map` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '中文名称',
  `key` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '英文key',
  `value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '值映射：json串',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='key映射';

-- ----------------------------
-- Records of k_key_map
-- ----------------------------
BEGIN;
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (1, '主键_ID', 'commission_detail_id', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (2, '大区', 'hq_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (3, '地区', 'area_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (4, '网点', 'dept_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (5, '收派类型', 'audit_type', '{\"1\":\"收\",\"2\":\"派\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (6, '员工工号', 'emp_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (7, '员工姓名', 'emp_name', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (8, '岗位', 'position', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (9, '运单ID', 'waybill_id', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (10, '运单号', 'waybill_no', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (11, '结算版本号', 'billing_version_no', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (12, '原寄地', 'original_zone_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (13, '目的地', 'destination_zone_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (14, '产品', 'product_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (15, '收入日期', 'income_dt', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (16, '运单性质', 'subtract_type', '{\"1\":\"正常\",\"2\":\"冲\",\"3\":\"补\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (17, '票值计提', 'ballot_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (18, '票数', 'ballot_qty', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (19, '住宅派件计提', 'is_send_ch', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (20, '运费计提', 'value_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (21, '难度系数提成', 'difficulty_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (22, '加班计提', 'over_time_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (23, '续重计提', 'ext_weight_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (24, '续重重量', 'ext_weight', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (25, '固定提成', 'tied_value_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (26, '运费', 'fee_item_amt', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (27, '计费重量', 'weight_of_charge_qty', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (28, '重货补贴计提', 'ext_heavy_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (29, '重货补贴票数', 'ext_heavy_qty', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (30, '重货补贴重量', 'ext_heavy_weight', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (31, '计提小计', 'commission_small_total', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (32, '转单计提分配比例', 'trans_rebate', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (33, '创建时间', 'create_tm', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (34, '提成类型', 'commission_type', '{\"1\":\"正常提成\",\"2\":\"个性化计提\",\"3\":\"转单计提\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (35, '客户月结账号', 'cust_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (36, '运单标识', 'waybill_type', '{\"1\":\"sws\",\"2\":\"ibil\",\"3\":\"cbil\",\"4\":\"ebil\",\"5\":\"bms\",\"6\":\"tms\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (40, '寄付月结账号', 'take_customer_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (41, '原始月结账号', 'ori_cust_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (42, '收件日期', 'takeover_tm', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (43, '派件日期', 'sending_tm', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (44, '原始产品编码', 'ori_product_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (45, '转单员工工号', 'transfer_emp_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (46, '到方客户电话号码', 'cust_phone', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (47, '是否接驳', 'is_connect', '{\"0\":\"否\",\"1\":\"是\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (48, '是否应用', 'is_apply', '{\"0\":\"否\",\"1\":\"是\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (49, '场景类型', 'scene_type', '{\"1\":\"集收\",\"2\":\"散收\",\"3\":\"集派\",\"4\":\"散派\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (50, '是否自取件', 'oneself_pickup_flg', '{\"1\":\"自取件\",\"other\":\"非自取件\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (51, '是否自寄件', 'self_send_flg', '{\"1\":\"自寄件\",\"other\":\"非自寄件\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (52, '是否给重货补贴计提', 'is_heavy_commission', '{\"0\":\"否\",\"1\":\"是\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (53, '原始到方客户电话码', 'ori_cust_phone', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (54, '付款方式变更', 'payment_change_type_code', '{\"0\":\"没有变更\",\"1\":\"寄付转第三方\",\"2\":\"到付转第三方\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (55, '付款方式', 'payment_type_code', '{\"1\":\"寄付\",\"2\":\"到付\",\"3\":\"第三方支付\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (56, '清单生成时间', 'input_tm_gmt', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (57, '动态计提', 'dynamic_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (58, 'AOI_代码', 'aoi_code', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (59, '是否应用AOI计提', 'is_apply_aoi', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (60, 'AOI计提', 'aoi_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (61, '下单渠道', 'order_sys_source', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (62, '_AOI_档位', 'aoi_gear', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (63, '是否妥投第三方', 'is_delivered_third_party', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (64, '动态激励计计提', 'motivation_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (65, '原场景类型', 'ori_scene_type', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (66, '序号', 'restore_seq', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (67, '代签人', 'agent_user', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (68, '代签地址', 'agent_address', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (69, 'LBS_定位', 'lbs_locate', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (70, '开城激励', 'kc_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (71, '低收差异化激励计提', 'ds_commission', NULL);
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (72, '是否顺收计提', 'order_type', '{\"1\":\"是\",\"other\":\"不是\"}');
INSERT INTO `k_key_map` (`id`, `name`, `key`, `value`) VALUES (73, '是否应用壹竿_AOI_', 'is_apply_yg_aoi', '{\"1\":\"是\",\"other\":\"不是\"}');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
